Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award)
نویسندگان
چکیده
From about the mid-1980' s to the mid-1990' s there was a flurry of research activity in the area of database triggers and constraints, seeing the development of numerous research proposals and prototypes. Soon thereafter, most mainstream database products ramped up their support for constraints and triggers, with expressive constraint specifications appearing in the SQL-92 standard, and both constraints and triggers in the SQL-99 standard.
منابع مشابه
Creation the fully integrated and flourishing assessment challenge award: Integration is the key
Medicine is now undertaking a paramount revolution that will alter the nature of healthcare from reactive to proactive. It is imperative to integrate experimental and computational investigation in order to appreciate complex biological systems in the era of precision medicine. In light of this revolution, we necessitate to precision medicine means such as systems approaches (genomics, radiogen...
متن کاملA reliability-based maintenance technicians’ workloads optimisation model with stochastic consideration
The growing interest in technicians’ workloads research is probably associated with the recent surge in competition. This was prompted by unprecedented technological development that triggers changes in customer tastes and preferences for industrial goods. In a quest for business improvement, this worldwide intense competition in industries has stimulated theories and practical frameworks that ...
متن کاملInvestigating the Effect of Financial Constraints and Different Levels of Agency Cost on Investment Efficiency
This research attempts to investigate the effect of financial constraints and different levels of agency costs on the investment efficiency of companies in Iran. Following the design of the financial risk assessment indexes, the transaction information was collected from the Stock Exchange in the five-year period of 2011-2015. The statistical sample consists of 128 companies selected by samplin...
متن کاملInstitut für Informatik III der Rheinischen Friedrich-Wilhelms-Universität Bonn Time-based Triggers for SQL: A Lingering Issue Revisited
Being able to activate triggers by timepoints reached or time intervals elapsed has been acknowledged by many authors as a valuable functionality of a DBMS. Recently, the interest in time-based triggers has been renewed in the context of data stream monitoring. However, up till now SQL triggers react to data changes only, even though research proposals and prototypes have been supporting severa...
متن کاملImproving Success Ratio in Multi-Constraint Quality of Service Routing
Multi-constraint quality-of-service routing will become increasingly important as the Internet evolves to support real-time services. It is well known however, that optimum multi-constraint QoS routing is computationally complex, and for this reason various heuristics have been proposed for routing in practical situations. Among these methods, those that use a single mixed metric are the mo...
متن کامل